select System_Id as ReqID, System_Title as ReqTitle, 
	(select cast(System_Id as nvarchar(8)) 
	+ '*' 
	from CurrentWorkItemView CWV2
	join vFactLinkedCurrentWorkItem FLCW2 on FLCW2.TargetWorkitemSK = CWV2.WorkItemSK
	where (SourceWorkItemSK = FLCW.SourceWorkItemSK) 
	and WorkItemLinkTypeSK = 2 -- need to change to more generic
	for XML PATH('')) as TaskID, '<a href="http://www.w3schools.com/">Visit W3Schools' + '</a>' test
from CurrentWorkItemView CWV
join vFactLinkedCurrentWorkItem FLCW on FLCW.SourceWorkItemSK = CWV.WorkItemSK
join FactWorkItemToCategory FWC on FWC.WorkItemTypeName = CWV.System_WorkItemType -- and FWC.TeamProjectSK = 67
join DimWorkItemCategory DWC on DWC.WorkItemCategorySK = FWC.WorkItemCategorySK
where 
--ProjectNodeSK = 67  and  --Gov-Dev Team Proj. 
DWC.ReferenceName = 'Microsoft.RequirementCategory' -- All WI's in Req. Category
Group by SourceWorkItemSK, System_Id, System_Title